package com.oa.srms.apps.business.student;

import java.util.List;

import com.oa.srms.apps.entity.student.StudentInfoValue;

public interface IStudentInfoService {
	public Integer addStudentInfo(String stuNo,String stuName,int studentId,int mailId,int avatarId) throws Exception;
	
	public void modifyStudentInfo(int id, String stuNo, String stuName, String stuPwd) throws Exception;
	
	public void deleteStudentInfo(int id) throws Exception;
	
	public void setStudentStates(Integer id, Integer states) throws Exception;
	
	public StudentInfoValue queryById(Integer id) throws Exception;
	
	public StudentInfoValue queryByStuNo(String stuNo) throws Exception;
	
	public List<StudentInfoValue> queryStudentInfo(Integer states) throws Exception;
	
	public List<StudentInfoValue> queryStudentInfoForSendMail(Integer studentState, Integer mailState) throws Exception;
	
	public List<StudentInfoValue> queryStudentInfo(String gender, Integer majorId, Integer grade) throws Exception;
	
	public List<StudentInfoValue> queryStudentInfo(String stuNo,String stuName, String gender, Integer majorId, Integer grade,Integer classNo,Integer states,Integer rows, Integer pageNo) throws Exception;
	
	public Integer getTotalPageNumber(String stuNo,String stuName, String gender, Integer majorId, Integer grade,Integer classNo,Integer states,Integer rows) throws Exception;
	
	public List<StudentInfoValue> queryStudentInfoAboveStates(String stuNo,String stuName, String gender, Integer majorId, Integer grade,Integer classNo,Integer states,Integer rows, Integer pageNo) throws Exception;
	
	public Integer getTotalPageNumberAboveStates(String stuNo,String stuName, String gender, Integer majorId, Integer grade,Integer classNo,Integer states,Integer rows) throws Exception;
	
	public Integer getTotalNumber();
}
